Returns the position of a value's first occurrence in a range with respect to the start of the range.
Format: MATCH (lookup-value, compare-range {,type})
Arguments:
ΓÇó lookup-value: A text or a numeric expression.
ΓÇó compare-range: A cell range.
ΓÇó type: Optional. Use -1 to indicate a descending range that contains values in decreasing order from left to right and top to bottom. Use 1 to indicate an ascending range, where values are in increasing order from left to right and top to bottom. Use 0 for an exact match, where range order is not important.
Note When specifying an ascending or descending range, be sure all the values are in order or you can get unexpected results.
Example:
MATCH ("f", B1..C5, 0) returns 6.
Shows that the letter f is the sixth element in the range. The function searches a row from left to right to find a match, and then drops down to look at the next row in the range.
